﻿<%@ Page Language="C#" MasterPageFile="~/Department/DepartmentMasterPage.master" AutoEventWireup="true" CodeFile="AddFinance.aspx.cs" Inherits="AddFinance" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <table style="width: 100%; height: 250px; background-color: transparent;">
        <tr>
            <td align="left" style="font-size: 1.2em; width: 2255px; font-family: 微软雅黑; height: 15px;
                background-color: transparent">
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 收据编号：<asp:TextBox ID="TextBox1" runat="server" Width="325px"></asp:TextBox>
                收费日期：<asp:TextBox ID="TextBox2" runat="server" Width="62px">2006-6-1</asp:TextBox><br />
                <br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 班级名称：<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="班级名称" DataValueField="班级名称" Width="130px">
                </asp:DropDownList>
                学生姓名：<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2" DataTextField="学生姓名" DataValueField="学籍编号" Width="85px">
                </asp:DropDownList>
                学期名称：<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="SqlDataSource3" DataTextField="学期名称" DataValueField="学期名称" Width="110px">
                </asp:DropDownList>&nbsp;<br />
                <br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;学费金额：<asp:TextBox ID="TextBox3" runat="server" Width="61px">0</asp:TextBox>
                书费金额：<asp:TextBox ID="TextBox4" runat="server" Width="55px">0</asp:TextBox>
                杂费金额：<asp:TextBox ID="TextBox5" runat="server" Width="44px">0</asp:TextBox>
                住宿费金额：<asp:TextBox ID="TextBox6" runat="server" Width="57px" OnTextChanged="TextBox6_TextChanged">0</asp:TextBox><br />
                <br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 合计金额(元)：<asp:TextBox ID="TextBox7" runat="server" BackColor="Silver" ReadOnly="True"
                    Width="102px">0</asp:TextBox>
                收费形式：<asp:TextBox ID="TextBox8" runat="server" Width="46px">现金</asp:TextBox>
                收费人员：<asp:TextBox ID="TextBox9" runat="server" Width="55px" BackColor="Silver" ReadOnly="True"></asp:TextBox>
                <asp:Button ID="Button4" runat="server" Text="计算" Width="73px" /><br />
                <br />
                &nbsp; &nbsp; &nbsp; &nbsp; 补充说明：<asp:TextBox ID="TextBox10" runat="server" Height="84px" TextMode="MultiLine"
                    Width="575px">暂无</asp:TextBox>&nbsp;<br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                &nbsp;&nbsp;
                <br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                <asp:Button
                    ID="Button1" runat="server" OnClick="Button1_Click" Text="新增" Width="73px" />
                &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="打印" Width="73px" />
                &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="保存" Width="73px" /></td>
        </tr>
    </table>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySchoolDBConnectionString %>"
        SelectCommand="SELECT * FROM [班级设置]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MySchoolDBConnectionString %>"
        SelectCommand="SELECT * FROM [学生档案] WHERE ([班级名称] = @班级名称) AND (学籍编号 NOT IN (SELECT 学籍编号 FROM 学生离校))">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="班级名称" PropertyName="SelectedValue"
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MySchoolDBConnectionString %>"
        SelectCommand="SELECT DISTINCT [学期名称] FROM [课程设置] WHERE ([班级名称] = @班级名称)">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="班级名称" PropertyName="SelectedValue"
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>

